/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_pricing_plan.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PRICING_PLAN
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_pricing_plan.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PRICING_PLAN::CTable_PRICING_PLAN( )
 :NPCRecordSet( )
{
  setTableName( "bill.PRICING_PLAN" );
  prepareTable();
  prepareQuery();
 
  PRICING_PLAN_ID.setField( "PRICING_PLAN_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( PRICING_PLAN_ID );
  makeKeyItem( PRICING_PLAN_ID ); 
  PRICING_PLAN_NAME.setField( "PRICING_PLAN_NAME", DATA_CHAR, 250, 0 );
  makeTableItem( PRICING_PLAN_NAME );
  PRICING_PLAN_CLASS.setField( "PRICING_PLAN_CLASS", DATA_CHAR, 3, 0 );
  makeTableItem( PRICING_PLAN_CLASS );
  PRICING_DESC.setField( "PRICING_DESC", DATA_CHAR, 4000, 0 );
  makeTableItem( PRICING_DESC );
  PARAM_DESC.setField( "PARAM_DESC", DATA_CHAR, 4000, 0 );
  makeTableItem( PARAM_DESC );
  LBS_BILL_CATALOG_ID.setField( "LBS_BILL_CATALOG_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( LBS_BILL_CATALOG_ID );
  PRICING_POLICY_DESC.setField( "PRICING_POLICY_DESC", DATA_CHAR, 250, 0 );
  makeTableItem( PRICING_POLICY_DESC );
  LBS_CATALOG_NAME.setField( "LBS_CATALOG_NAME", DATA_CHAR, 50, 0 );
  makeTableItem( LBS_CATALOG_NAME );
  LATN_ID.setField( "LATN_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( LATN_ID );
  LBS_STANDARD_CODE.setField( "LBS_STANDARD_CODE", DATA_DOUBLE, 22, 0 );
  makeTableItem( LBS_STANDARD_CODE );
  STATE.setField( "STATE", DATA_CHAR, 3, 0 );
  makeTableItem( STATE );
}


CTable_PRICING_PLAN::CTable_PRICING_PLAN( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "bill.PRICING_PLAN" );
  prepareTable();
  prepareQuery();
 
  PRICING_PLAN_ID.setField( "PRICING_PLAN_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( PRICING_PLAN_ID );
  makeKeyItem( PRICING_PLAN_ID ); 
  PRICING_PLAN_NAME.setField( "PRICING_PLAN_NAME", DATA_CHAR, 250, 0 );
  makeTableItem( PRICING_PLAN_NAME );
  PRICING_PLAN_CLASS.setField( "PRICING_PLAN_CLASS", DATA_CHAR, 3, 0 );
  makeTableItem( PRICING_PLAN_CLASS );
  PRICING_DESC.setField( "PRICING_DESC", DATA_CHAR, 4000, 0 );
  makeTableItem( PRICING_DESC );
  PARAM_DESC.setField( "PARAM_DESC", DATA_CHAR, 4000, 0 );
  makeTableItem( PARAM_DESC );
  LBS_BILL_CATALOG_ID.setField( "LBS_BILL_CATALOG_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( LBS_BILL_CATALOG_ID );
  PRICING_POLICY_DESC.setField( "PRICING_POLICY_DESC", DATA_CHAR, 250, 0 );
  makeTableItem( PRICING_POLICY_DESC );
  LBS_CATALOG_NAME.setField( "LBS_CATALOG_NAME", DATA_CHAR, 50, 0 );
  makeTableItem( LBS_CATALOG_NAME );
  LATN_ID.setField( "LATN_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( LATN_ID );
  LBS_STANDARD_CODE.setField( "LBS_STANDARD_CODE", DATA_DOUBLE, 22, 0 );
  makeTableItem( LBS_STANDARD_CODE );
  STATE.setField( "STATE", DATA_CHAR, 3, 0 );
  makeTableItem( STATE );
}

CTable_PRICING_PLAN::~CTable_PRICING_PLAN( )
{
    close();
}

